﻿SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Andreas Kraus
-- Create date: 2007-03-27
-- Description: Who Is Online Box
-- =============================================
CREATE PROCEDURE [dbo].[xx_WhoIsOnline]
@TimeWindow DATETIME
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
SELECT UserName FROM aspnet_Users
WHERE IsAnonymous = 'FALSE' AND LastActivityDate > @TimeWindow
END
GO 
